CREATE TABLE [dbo].[ListItem]
(
[ListItemKey] [uniqueidentifier] NOT NULL CONSTRAINT [DF_ListItem_ListItemKey] DEFAULT (newid()),
[ListKey] [uniqueidentifier] NOT NULL,
[ObjectKey] [uniqueidentifier] NOT NULL,
[IsDisabled] [bit] NOT NULL CONSTRAINT [DF_ListItem_IsDisabled] DEFAULT ((0)),
[LinkedObjectKey] [uniqueidentifier] NULL,
[CreatedByUserKey] [uniqueidentifier] NOT NULL,
[CreatedOn] [datetime] NOT NULL CONSTRAINT [DF_ListItem_CreatedOn] DEFAULT (getdate()),
[MarkedForDeleteOn] [datetime] NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[ListItem] ADD CONSTRAINT [PK_ListItem] PRIMARY KEY NONCLUSTERED ([ListItemKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_ListItem_CreatedByUserKey] ON [dbo].[ListItem] ([CreatedByUserKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_ListItem_ListKey] ON [dbo].[ListItem] ([ListKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_ListItem_ObjectKey] ON [dbo].[ListItem] ([ObjectKey]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ListItem] ADD CONSTRAINT [FK_ListItem_ListMain] FOREIGN KEY ([ListKey]) REFERENCES [dbo].[ListMain] ([ListKey])
GO
ALTER TABLE [dbo].[ListItem] ADD CONSTRAINT [FK_ListItem_UserMain_CreatedBy] FOREIGN KEY ([CreatedByUserKey]) REFERENCES [dbo].[UserMain] ([UserKey])
GO